2015-07-07 - 20377.100 - Enhancement - Currency Conversion in Inventory reports #CrystalReportsSupport

ENHANCEMENT

20377.100 - Currency Conversion in Inventory reports

Requirement Summary

---

Need to add currency conversion parameter, similar to other reports in BI, to the INV300 & INV310 reports.

Admin Info

---

Purpose	Need to add currency conversion parameter, similar to other reports in BI, to the INV300 & INV310 reports.
Requested By	Takehiko Kurata
Spec Created By	Dhananjay G
Spec Created Date	07/07/2015
Spec QA by	Uday Kumar P
Objects	INV300 & INV310
Document Status	Complete

Estimates

---

SNo	Activity	Estimation in Hours
1	Research	00
2	Documentation	08
3	Development/ Config	30
4	Unit test in DEV	04
5	Unit test in QUA	00
6	Other activity	08
	TOTAL	48

References

---

Prior Tickets

20325

Documents

None

Spec Changes

---

SNo	Change Details	Requested By	Requested On	Notes if any
1	Need to add another formula to the report that changes the currency symbol in coordination with the actual currency	Mark H	07/21/2015

Functional Requirement

---

Purpose/WHY:

Need to add currency conversion parameter, similar to other reports in BI, to the INV300 & INV310 reports.

In Scope:

INV300 & INV310 reports.

Out of Scope:

INV350 report.

Solution Summary

---

BW Changes:
1. Need to add Fiscal period & Fiscal year to the weekly inventory infocube.
2. Need to write the logic to populate data for Fiscal Year & Fiscal period based on the current date.
3. Need to add Fiscal year and Fiscal period to related BEx queries.
4. Need to validate the data in BPD & BPQ.
5. Need to collect the changes into transport request.

Crystal Changes:
1. Need to add currency conversion parameter in INV300 & INV310 reports.
2. Need to link the currency conversion file "Currency Conversion Rates" with these reports.
3. Need to validate the data before and after conversions.
4. Need to place the report in BI development and promote it to BI Production after successful validation.
5. Need to add another formula to the report that changes the currency symbol in coordination with the actual currency.

Test Plan

Test ID	Test Scenario	Expected Results
1	Report Format.	Should be as per NEC crystal standard checklist.
2	Execute Crystal Report in Crystal Designer tool after changes.	Report should execute successfully in Crystal Designer tool.
3	Schedule the Report in NEC BI Launch Pad.	Report should execute successfully in NEC BI Launch Pad.
4	Routine logic in End Routine.	Values should be correctly populated in fields.

Solution Details

---

BW Changes:
1. Need to add Fiscal Year(0FISCYEAR) & Fiscal Period(0FISCPER3) to the weekly inventory infocube ZIC_INVW.
2. Need to write the logic to populate data for Fiscal Year(0FISCYEAR) & Fiscal period(0FISCPER3) based on the current date(SY-DATUM).
3. Need to add Fiscal year and Fiscal period to related BEx queries ZIC_INVW_Q001 and ZIC_INVW_Q002.
4. Need to validate the data in BPD & BPQ.
5. Need to collect the changes into transport request.

Crystal Changes:
1. Need to add currency conversion parameter in INV300 & INV310 reports.
2. Need to link the currency conversion file "Currency Conversion Rates" with these reports.
3. Need to add another formula to the report that changes the currency symbol in coordination with the actual currency
4. Need to save and schedule reports in the BOBJ Development Server.
5 Need to validate the data before and after conversions.
6. Need to place the report in BI development and promote it to BI Production after successful validation.

Issues

---

Currency Conversion file could not be linked to the reports without Fiscal year and Fiscal period in the inventory infocube, so there was a need for BW Enhancement.